

<%

//String name = "winpum@gmail.com";
 String name = "";
        if(session.getAttribute("usuario") == null){
            response.sendRedirect("../PRINCIPAL/sesionExpirada.jsp");
        }else{
            name = session.getAttribute("usuario").toString();
        }
 
 out.write(name);
%>

<%@page import="java.util.Date"%>
<%@page import="java.util.Calendar"%>
<%@page import="java.sql.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>ANALISIS Y DISEÑO 2</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="../CSS/default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<!-- start header -->
<jsp:useBean id="db" scope="request" class="conexion.DB" />
<div id="header">
<img src="../imagenes/usac1.jpg"/>        
	<h1><a href="#">FANTASY FOOTBALL</a></h1>
	<p><a href="#">USAC - AYD2</a></p>               
</div>
<!-- end header -->
<!-- star menu -->
<div id="menu">
	<ul>
		<li class="current_page_item"><a href="inicio.jsp">INICIO</a></li>
                <li><a href="crear_plantilla.jsp">PLANTILLA</a></li>
                 <li><a href="escuadra.jsp">ESCUADRA</a></li>
                <li><a href="cerrarSesion.jsp">CERRAR SESION</a></li>
	</ul>
</div>
<!-- end menu -->
<!-- start page -->
<div id="page">
	<!-- start content -->
	<div id="content">
		<div class="post">
			<div class="title">
				<h2><a href="">TRANSFERENCIAS - REALIZADAS</a></h2>
				<p><small>fase 1.4 </small></p>
			</div>
<%
                    String correo=name;//"winpum@gmail.com";                     
                    String nombre_plan="";
                    String opciones="";
                    String dinero="";
                    Boolean entra=false;
                              if(db.connect()){
                                ResultSet rs=  null;                                
                               try{
                                rs = db.seleccionar("*", "player", " id_player = (Select id_player_squad from squad where id_player_squad = (select id_player_squad_pool from pool))");
                                out.write("<table border=1 cellpadding=4 cellspacing=0>");
                                out.write("<tr>  <th> Nombre </th><th> Edad </th> <th> precio </th> </tr>");
                                 while(rs.next()){
                                   
                                   String nombre = rs.getString(2);
                                   String edad = rs.getString(3);
                                   String precio = rs.getString(4);                                
                                out.write("<tr> "+
                                    
                                    "<td> "+nombre+ " </td>"+
                                    "<td> "+edad+ " </td> "+                                    
                                    "<td> "+precio+ " </td> "+
                                    "</tr>");
                                   
                                  }
                                out.write("</table> ");
                                    }catch(Exception e){
                                    opciones += "error = " + e.toString();
                                }
                              }                              
                             %>
                                                                                                                              
		</div>
                          
    
		<div class="post">
			<div class="entry">
				<blockquote>
				</blockquote>
			</div>
			<p class="links">  <a href="#" class="comments">Inicio</a> </p>
                        <CENTER>
                         <H2></H2>
                         <% 
                         Date fecha = new Date();
                         out.print("<b>Hoy es:</b> ");
                         out.print(fecha.getDate());
                         out.print(" / ");
                         out.print(fecha.getMonth()+1);
                         out.print(" / ");
                         out.print(fecha.getYear()+1900);
                         %>
                         </CENTER> 
		</div>
	</div>
	<!-- end content -->
	<!-- start sidebar -->
	<div id="sidebar">
		<div id="search">
			<h2>USUARIO</h2>			
		</div>
		<ul>
			<li id="categories">
				<h2>MENU</h2>
				<ul>
					<li><a href="../PRINCIPAL/liga.jsp">LIGA</a>  </li>
                                        <ul>
                                        <li><a href="escuadra.jsp">ESCUADRA</a> </li>                                                        
                                        </ul>                                        
                                        <li><a href="crear_plantilla.jsp">PLANTILLA</a></li>
					<li><a href="../PRINCIPAL/equipo.jsp">EQUIPOS</a> </li>
                                        <li><a href="../PRINCIPAL/jugador.jsp">JUGADORES</a> </li>                                        
                                        <img src="../imagenes/pelota.png" alt="" />
				</ul>
			</li>
						
		</ul>
	</div>
	<!-- end sidebar -->
	<div id="extra" style="clear: both;">&nbsp;</div>
</div>
<!-- end page -->
<!-- start footer -->
<div id="footer">
	<p class="legal"> &copy;2012 Usac. All Rights Reserved.
		&nbsp;&nbsp;&bull;&nbsp;&nbsp;		
                </p>
</div>
<!-- end footer -->
</body>
</html>
